# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophiecc
# Description of the table:        Cross-correlation functions
# SQL constraint on fields:        [sseq =1043120]
# Order by:                        seq
# Description of each column
# seq: ----------------- Sequence number
# $link[objname]: ------ Designation of the object
# date: ---------------- Observation date
# $link[slen]: --------- Length of the series
# mask: ---------------- Name of the mask
# ccf_offline: --------- Offline CCF
# $field[rv]: ---------- Radial velocity
# fwhm: ---------------- FWHM of the correlation peak
# span: ---------------- Bissector span
# maxcpp: -------------- Maximum number of counts per pixel
# contrast: ------------ Contrast of the CCF
# lines: --------------- Number of lines used for the CCF
# $link['view_head']: -- See the header of the cross-correlation file
# $link['get_ccf']: ---- Download the cross-correlation function FITS file
# $link['view_ccf']: --- View the cross-correlation function
#-------------- ------- --------------- ---- -- --------------- ---------------- -------- ------- --------------- ------ --------------- ----------- --------- ----------
#seq    $link[o date            $lin ma c $field[rv]       fwhm     span    maxcpp  contra l $link['view $link['ge $link['vie
#       bjname]                 k[sl sk c                                           st     i _head']     t_ccf']   w_ccf']   
#                               en]     f                                                  n                                 
#                                       _                                                  e                                 
#                                       o                                                  s                                 
#                                       f                                                                                    
#                                       f                                                                                    
#                                       l                                                                                    
#                                       i                                                                                    
#                                       n                                                                                    
#                                       e                                                                                    
#------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ----------
1043120 HD028307 2010-09-22   20 K5 0  42.496  0.0005     8.268   0.035   16166  39.69 6981 view_head   get_ccf   view_ccf  
1043130 HD028307 2010-09-22   20 K5 0  42.498  0.0005     8.270   0.037   15854  39.67 6981 view_head   get_ccf   view_ccf  
1043140 HD028307 2010-09-22   20 K5 0  42.501  0.0004     8.274   0.037   22711  39.79 6981 view_head   get_ccf   view_ccf  
1043150 HD028307 2010-09-22   20 K5 0  42.495  0.0005     8.269   0.038   17067  39.72 6981 view_head   get_ccf   view_ccf  
1043160 HD028307 2010-09-22   20 K5 0  42.501  0.0006     8.269   0.038   12160  39.57 6981 view_head   get_ccf   view_ccf  
1043170 HD028307 2010-09-22   20 K5 0  42.497  0.0005     8.263   0.038   13977  39.66 6981 view_head   get_ccf   view_ccf  
1043180 HD028307 2010-09-22   20 K5 0  42.498  0.0008     8.260   0.036    6909  39.22 6981 view_head   get_ccf   view_ccf  
1043190 HD028307 2010-09-22   20 K5 0  42.495  0.0007     8.256   0.037    8134  39.36 6981 view_head   get_ccf   view_ccf  
1043200 HD028307 2010-09-22   20 K5 0  42.496  0.0010     8.257   0.037    4721  38.90 6981 view_head   get_ccf   view_ccf  
1043210 HD028307 2010-09-22   20 K5 0  42.499  0.0009     8.257   0.034    5753  39.08 6981 view_head   get_ccf   view_ccf  
1043220 HD028307 2010-09-22   20 K5 0  42.493  0.0008     8.254   0.040    7539  39.33 6981 view_head   get_ccf   view_ccf  
1043230 HD028307 2010-09-22   20 K5 0  42.498  0.0007     8.260   0.035    8433  39.41 6981 view_head   get_ccf   view_ccf  
1043240 HD028307 2010-09-22   20 K5 0  42.499  0.0006     8.261   0.034   11345  39.58 6981 view_head   get_ccf   view_ccf  
1043250 HD028307 2010-09-22   20 K5 0  42.497  0.0005     8.262   0.039   17062  39.75 6981 view_head   get_ccf   view_ccf  
1043260 HD028307 2010-09-22   20 K5 0  42.496  0.0004     8.263   0.039   26621  39.90 6981 view_head   get_ccf   view_ccf  
1043270 HD028307 2010-09-22   20 K5 0  42.492  0.0004     8.262   0.039   27107  39.92 6981 view_head   get_ccf   view_ccf  
1043280 HD028307 2010-09-22   20 K5 0  42.497  0.0004     8.261   0.037   28270  39.92 6981 view_head   get_ccf   view_ccf  
1043290 HD028307 2010-09-22   20 K5 0  42.493  0.0004     8.257   0.034   25447  39.91 6981 view_head   get_ccf   view_ccf  
1043300 HD028307 2010-09-22   20 K5 0  42.494  0.0004     8.258   0.034   25268  39.91 6981 view_head   get_ccf   view_ccf  
1043310 HD028307 2010-09-22   20 K5 0  42.498  0.0004     8.261   0.036   24552  39.89 6981 view_head   get_ccf   view_ccf  
#-- end of data table ----------------------------------------------------------
# 20 lines were successfully retrieved